I'd like to store a simple map of key-value strings as a field in my PostgreSQL table. I intend to treat the map as a whole; i.e, always select the entire map, and never query by its keys nor values.
I've read articles comparing between hstore, json and jsonb, but those didn't help me choose which data-type is most fitting for my requirements, which are:
- Only key-value, no need for nesting.
- Only strings, no other types nor
null.
- Storage efficiency, given my intended use for the field.
- Fast parsing of the queried maps.
What data-type would best fit my use case?